select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Snazzy Appliqued Ruffled Hot Pink Dress for Sweet 16 on Sale
One Shoulder Teal Dresses for Quince with Orange Flowers
Pretty Two-toned Dress for Quinceanera with Short Puff Sleeves
Classy Embroidery White and Purple Quinceanera Party Dress
Impressive Corset Appliqued White and Green Quinceanera Dress
Corset Beaded Ruffled Dress for 15 Birthday Party in Fuchsia
Spring Green Taffeta and Animal Print Sweet 16 Quinceanera Dress
Orange Red Sweet Sixteen Quinceanera Dress with Pick ups Appliques
Blue and White Sweet Sixteen Quinceanera Dresses with Embroidery
Appliqued Hot Pink Organza Sweetheart Ruffles Sweet 15 Dresses
Embroidered and Frilly Purple Sweetheart Quinceanera Gown Dress
Red Ball Gown Taffeta Dresses for 15 with Pick ups and Embroidery
Green and Blue Organza Dresses for 15 with Beading and Ruffles
Colorful Leopard and Organza Dresses for 15 with Ruffles Beading
Pink and Watermelon Dresses for A Quince with Appliques Pick ups
2013 Appliqued Blue and Lavender Dress for A Quince with Ruffles
Appliques Accent Sweetheart Dresses for A Quinceanera in Hot Pink
Ruffled Layers Accent Strapless Sweet 16 Dresses in Green and Silver
Beaded and Ruched Orange and Black Quinceanera Gowns with Ruffles
Spring Green and Black Quinceanera Gowns with Appliques Ruffles
Beading and Ruffles Accent Quinceanera Gowns in Multiple Colors
Beading Ruches Accent Sweetheart Quinceanera Dress in Multiple Colors
Zebra Print Colorful One Shoulder Ruffled Quinceanera Gown Dress
Ruffled Spring Green Quinceanera Gown Dresses with Beading and Bow
2013 Popular Colorful Quinceanera Gown with Flowers and Ruffles
Embroidery and Lace-up Accent Quinces Dresses in Hot Pink 2013
Beading and Pick ups Accent Blue Organza Quinceanera Dress 2013
Turquoise Sweetheart Quinceanera Dress with Sequins and Beading
Pink and Black Quinceanera Dress in Organza and Zebra Print Fabric
V-neck Red and Black Sweet 16 Dress with Appliques and Ruffles